SUPPORT / SAMPLES & SAS NOTES
 

Support

Problem Note 48813: An 0C4 abend might occur when you are using a DBSLICEPARM= LIBNAME or DATA Set option when accessing a DB2 table

DetailsAboutRate It

Using SAS/ACCESS® Interface to DB2 on z/OS to access a DB2 table that contains a TIMESTAMP column, might result in an 0C4 abend. The actual error message and traceback varies. It might look like one of the following:

ERROR: System abend 0C4 occurred in module SASSQX function sqxcrta_get_next at offset 000538.
ERROR: Traceback will be attempted...

NOTE: Traceback called
NOTE:  Module  Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASSQX   @@669271 000A92    0 sqxcrta_open
NOTE: SASSQX   @@669257 0001CE    0 sqxcrta_init
NOTE: SASSQX    SQXEXEC 00012A    0
NOTE: SASSQX    SQLLOOP 000CDC    0
NOTE: SASSQL     SASSQL 000302    0
NOTE: SASHOST   UNKNOWN 002DD0    0


ERROR: System abend 0C6 occurred in module UNKNOWN function   YYVGET at offset E17D59
ERROR: Traceback will be attempted...

NOTE: Traceback called
NOTE:  Module  Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASSQX   @@271913 000858    0 sqxsrc_get_next
NOTE: SASSQX   @@669285 000308    0 sqxcrta_get_next
NOTE: SASSQX   @@669271 000A92    0 sqxcrta_open
NOTE: SASSQX   @@669257 0001CE    0 sqxcrta_init
NOTE: SASSQX    SQXEXEC 00012A    0
NOTE: SASSQX    SQLLOOP 000CDC    0
NOTE: SASSQL     SASSQL 000302    0
NOTE: SASHOST   UNKNOWN 002DD0    0


ERROR: System abend 0C4 occurred in module SASWGP function  WGCLOSE at offset 00018A
ERROR: Traceback will be attempted...

NOTE: Traceback called
NOTE:  Module  Function Offset Line
NOTE: -------- -------- ------ ----
NOTE: SASYOIO    YVGETT 00006C    0
NOTE: SASYOIO   YOCLOSE 000FCC    0
NOTE: SASSQX   @@271945 00009C    0 sqxsrc_close
NOTE: SASSQX   @@669303 0000C4    0 sqxcrta_close
NOTE: SASSQX   @@669285 000402    0 sqxcrta_get_next
NOTE: SASSQX   @@669271 000A92    0 sqxcrta_open
NOTE: SASSQX   @@669257 0001CE    0 sqxcrta_init
NOTE: SASSQX    SQXEXEC 00012A    0
NOTE: SASSQX    SQLLOOP 000CDC    0
NOTE: SASSQL     SASSQL 000302    0
NOTE: SASHOST   UNKNOWN 002DD0    0

There is no workaround for this issue.



Operating System and Release Information

Product FamilyProductSystemSAS Release
ReportedFixed*
SAS SystemSAS/ACCESS Interface to DB2z/OS9.3 TS1M09.4 TS1M0
* For software releases that are not yet generally available, the Fixed Release is the software release in which the problem is planned to be fixed.